<html>
<head><META http-equiv=Content-Type content="text/html; charset=utf-8">

<title>国际学术会议及期刊</title>
<link href="../css/bootstrapmin.css" rel="stylesheet" media="screen">
  <link href="../css/style.css" rel="stylesheet">
 <script type="text/javascript" src="../js/header.js"></script>
<link rel="stylesheet" type="text/css" href="../css/css3.css">
 
</head>

<body style="background-color: #037BB9;">

<?php
	require("header.php");
?>
<div style='margin-left:230px;width:960;'>
    <?php
	
	require("../DBops.php");
	session_start();
	if(isset($_SESSION['user'])){
		echo "<div style='height:30px;background:#A4D3EE;'>
              <p  style='margin-right:10px;float:right;'>登录为: <a href = \"infor.php?id=".$_SESSION['user']."\">".$_SESSION['user']."</a></font>&nbsp&nbsp<a  onclick=\"if(confirm('确定要退出系统吗?')){parent.location.href ='logout.php'}\" href=\"javascript:void(0)\">退出</a></font></p></div>";
	}
	else
	{
		$_SESSION['userurl'] = $_SERVER['REQUEST_URI']; 
		echo "<div style='height:30px;background:#A4D3EE;'>
				<ul>
              <li  style='margin-right:10px;float:right;'><a href ='login.php'>登录</a></div>";
	}
	
	?>
    <table style="background:url(../img/9--.jpg) repeat-y;height:700px; margin-top:0px;" border='0'>
      <tbody>
        <tr>
          <td class="h2" height="40" colspan="3" align="center"><br />

<?php
if($_GET['table'] == 'conferences')
$title='国际学术会议';
else
$title='国际学术期刊';

echo "<span id=''
	class=\"\">&nbsp".$_GET['class']."</span>


          <br />
          <hr style='margin-left:5px;' color=\"#003366\" width=\"900px\" />
          </td>
        </tr>
        <tr>
          <td style=\"padding-bottom: 0px; padding-left: 20px; padding-right: 25px; padding-top: 15px\" valign=\"top\" align=\"left\">

<span id='pt9491field'
	class=\"h5\"><p>
<style type=\"text/css\">
body {font-size:10.5pt;line-height:26px; color:#333; text-align:left}
.biaoti{ font-size:10.5pt; font-weight:bold; line-height:28px; color: #FFF; text-align:center;border-left:#999 solid 1px; background:#274F89}
.dyg{font-size:10.5pt;line-height:26px;  border-left: #000 solid 1px;border-bottom:#000 solid 1px;}
.dyg1{ font-size:10.5pt;border-left: #000 solid 1px;border-bottom:#000 solid 1px; line-height:18px;padding-top:5px; padding-bottom:5px;}
.dyg1 a{text-decoration:none; color:#36C}
.dyg1 a{text-decoration:none; color:#36C}
.dyg1 a:link{text-decoration:none; color:#36C}
.dyg1 a:visited{text-decoration:none; color:#36C}
.dyg1 a:hover{text-decoration:none; color:#603}
.dyg a:link{text-decoration:none; color:#36C}
.dyg a:visited{text-decoration:none; color:#36C}
.dyg a:hover{text-decoration:none; color:#603}
.lei{font-size:16PX;line-height:32PX; color:#333; font-weight:bold;text-align:left; padding-top:10PX; font-family:\"黑体\"; text-indent:1em;}</style></p>
<div class=\"lei\">
<div align=\"center\">".$title."<br />&nbsp&nbsp(".$_GET['class'].")</div>
</div>
<div class=\"lei\"></div>";

include 'mySqlSetup.php';//数据库设置

$db = mysql_connect($HOST,$USER,$PASSWD) or die("数据库链接失败") or

die("Could not connect to database.");//连接数据库

mysql_query('set names utf8') or die("设置数据库语言失败");//mysql_query("set names 'gbk'");//输出中文

mysql_select_db('lab');       //选择数据库

if($_GET['table'] == 'conferences')
{	
	$sql="select number, abbrname, fullname, CCFlevel, theme,deadLine,acRatio,url from ".$_GET['table']." where area='".$_GET['class']."'";
	$str='<td><font color="white" size=3px>序号</font></td>'
		.'<td><font color="white" size=3px>会议简称</font></td>'
		.'<td><font color="white" size=3px>会议全名</font></td>'
		.'<td><font color="white" size=3px>CCF等级</font></td>'
		.'<td><font color="white" size=3px>收录范围</font></td>'
		
		
		.'<td><font color="white" size=3px>召开时间</font></td>'
		.'<td><font color="white" size=3px>平均接受率</font></td>'
		.'<td><font color="white" size=3px>网址</font></td>'
		;
}
else
{
	if($_GET['class'] == '多媒体(视频)传输')
		$class='多媒体（视频）传输';
	else
		$class=$_GET['class'];
		
	$sql="select number, abbrname, fullname, CCFlevel,  type, `index`, impactFactors, subregion,  theme, difficulty, url from ".$_GET['table']." where area='".$class."'";
	$str='<td><font color="white" size=3px>序号</font></td>'
		.'<td><font color="white" size=3px>期刊简称</font></td>'
		.'<td><font color="white" size=3px>期刊全名</font></td>'
		.'<td><font color="white" size=3px>CCF等级</font></td>'
		
		.'<td><font color="white" size=3px>期刊类型</font></td>'
		.'<td><font color="white" size=3px>索引</font></td>'
		.'<td><font color="white" size=3px>最新影响因子</font></td>'
		.'<td><font color="white" size=3px>分区</font></td>'
		
		.'<td><font color="white" size=3px>收录题材</font></td>'
		
		.'<td><font color="white" size=3px>难度</font></td>'
		.'<td><font color="white" size=3px>网址</font></td>'
		;
}
$sql.=";";
//echo $sql;
if(!$result=mysql_query($sql,$db))
{
	echo "error:".mysql_error();
}
echo '<table frame=border border=1 cellspacing=0 style="margin:15px;border:1px solid #000;" >';

echo '<tr style="background: #274f89">';

echo $str;

echo '</tr>';

while($arr = mysql_fetch_assoc($result)){
echo '<tr>';
foreach($arr as $each){
echo '<td>'.$each.'</td>';
}

echo '</tr>';
}

echo '</table>';

?>

<p>&#160;</p></span>


          </td>
        </tr>
        <tr>
          <td style="padding-bottom: 15px; padding-left: 20px; padding-right: 25px; padding-top: 15px" valign="top" align="left"><span style="font-size: medium"><b><span style="color: #000080"><span>　点击下载：<br />
          </span></span></b></span><b><span style="color: #000080"><span style="font-size: larger"><br />
          </span></span></b>　　
          


<span id='pt0005field'
	class=""><a href="重点关注的期刊及会议论文信息汇总.xls">重点关注的期刊及会议论文信息汇总.xls</a></span>


          </td>
        </tr>
      </tbody>
    </table>
	</div>

    <tr>
    </tr>
    <td align="center" valign="top" background="../paiming/images/4.jpg" border="0" width="960" height="81"></td>
    &#160;
  </body>
</html>
